package kr.co.medical.dao;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;

import kr.co.medical.dto.Jupsoo;
import kr.co.medical.dto.Master;
import kr.co.medical.dto.Patient;
import kr.co.medical.dto.RowNumDTO;

public interface PatientDao {
	public Patient getPatient(String patient_id, String password)
			throws ClassNotFoundException, SQLException;

	public int insert(Patient patient) throws ClassNotFoundException,
			SQLException;

	public int insertRole(String user_id) throws ClassNotFoundException,
			SQLException;

	public Master getMaster(String staff_id, String password)
			throws ClassNotFoundException, SQLException;

	public List<Patient> selectPatient() throws ClassNotFoundException,
			SQLException;

	public List<Patient> NameCheck(HashMap<String, String> map)
			throws ClassNotFoundException, SQLException;

	public Patient checkId(String user_id) throws ClassNotFoundException,
			SQLException;

	public Patient reservation(String user_id) throws ClassNotFoundException,
			SQLException;

	public Patient patientInfo(String user_id) throws ClassNotFoundException,
			SQLException;

	public int updatePatient(String user_id, String password, String zipcode1,
			String zipcode2, String addr1, String addr2, String tel)
			throws ClassNotFoundException, SQLException;

	// 예약 접수 현황 조회하기
	public List<Jupsoo> selectRes(String user_id, int startRow, int endRow)
			throws ClassNotFoundException, SQLException;

	// 예약 취소
	public int cancelRes(String jupsoo_id) throws ClassNotFoundException,
			SQLException;

	public int cancelwating(String jupsoo_id) throws ClassNotFoundException,
			SQLException;

	// 환자 예약 조회 페이징 처리
	public int getCount(String user_id) throws ClassNotFoundException,
			SQLException;
	
	public Patient searchId(String name, String jumin1, String jumin2) throws ClassNotFoundException,
	SQLException;
	
	public Patient searchPwd(String user_id, String jumin1, String jumin2) throws ClassNotFoundException,
	SQLException;
}
